Tabela HierarchyType

Definicja tabeli HierarchyType

Name

HierarchyType

Code

HierarchyType

Comment

PL: Opis hierarchii placówek – w LX uzywane tylko HierarchyTypeID = 162 i 40
EN: Organization units hierarchy description – in LX uses only HierarchyTypeID = 162 and 40


Lista kolumn tabeli HierarchyType

Name

Code

HierarchyTypeID

HierarchyTypeID

Active

Active

InterfaceCd

InterfaceCd


Kolumna HierarchyTypeID tabeli HierarchyType

Definicja kolumny HierarchyTypeID tabeli HierarchyType

Name

HierarchyTypeID

Code

HierarchyTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Active tabeli HierarchyType

Definicja kolumny Active tabeli HierarchyType

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InterfaceCd tabeli HierarchyType

Definicja kolumny InterfaceCd tabeli HierarchyType

Name

InterfaceCd

Code

InterfaceCd

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Lista kluczy tabeli HierarchyType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli HierarchyType

Definicja klucza Identifier_1 tabeli HierarchyType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment